Our YouTube video which explains how to file address lists by
zip code can be found at:
Find Zip Codes in a Radius Using
Excel
Typically, this problem is caused by the zip code fields not being set to text or extra non-printing characters appearing in the zip code column when you imported
the data.
As a first step make sure your column with zip code data is set to text. This
will prevent leading zeroes from being removed from zip codes and make sure that
the text zip returned by the CDXRadius function matches the zip code column format.
If you have zip + 4 data in
your zip codes you can compensate for this a follows:
If your address list zip code was in cell F2 then where the video refers to the
distance formula
=VLOOKUP(F2,ZipList,2,FALSE)
change this to:
=VLOOKUP(LEFT(TRIM(F2),5),ZipList,2,FALSE)
and copy this to all the other
cells in this column. This will make sure that only five characters are returned
and that the format will be set to text without non-printing characters.
We've set up some example template
on our website which you can find at:
and